SELECT DISTINCT shop_view_active_item.*
							FROM shop_item_has_category
							  INNER JOIN shop_view_active_item ON (
							    shop_view_active_item.company = shop_item_has_category.company AND 
							    shop_view_active_item.shop_code = shop_item_has_category.shop_code AND 
							    shop_view_active_item.language_code = shop_item_has_category.language_code AND 
                                    ( 
                                      shop_item_has_category.item_no = shop_view_active_item.item_no 
                                    )
							    )
							  
							  WHERE (shop_item_has_category.category_line_no = 158554)
							  AND shop_view_active_item.language_code = 'ENU'
							  AND shop_view_active_item.company = 'DESOI'
							  AND shop_view_active_item.shop_code = 'B2B'
							  AND shop_item_has_category.company = 'DESOI'
							  AND shop_item_has_category.shop_code = 'B2B'
							  AND shop_item_has_category.language_code = 'ENU'
							  AND shop_item_has_category.category_shop_code = 'B2B'
							 
                                        
                    
                    
                            
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
          
                    
                        
                    
                      
                    
                        
                        
                          
                          
                                
                                  Los datos de acceso introducidos no son correctos. Por favor, inténtelo de nuevo.                                
                            
                                
                                
                                
                                convertirse en un cliente
                                ¿Aún no tienes acceso a Internet? Solicite sus datos de acceso aquí.
                                
                                 
                                 
                                 
                          
                          
                           
                         
                          
                         
                       
                     
                  
        
         
                
                                                             
    Añadir el artículo a 
carro de la compra
    
    Agregar todos los artículos seleccionados 
 a la cesta de la compra
    
     Eliminar el artículo de la cesta de la compra 
    
     Lista de vigilancia
    
     Lista de vigilancia
    
     Artículo no en stock 
Posible pedido anticipado
    
     Artículo en low
cantidad en stock
    
     Artículo en suficiente 
cantidad en stock
    
     Artículo en entrada
    
    
     El artículo está incluido en una acción 
 en curso
IMPORTANT INFORMATION:
HOW TO ORDER SPARE AND WEAR PARTS
It is extremely important to state the SERIAL NUMBER when ordering spare parts! This is the only way we can ensure that the correct parts are supplied.
The serial number can be entered in the ‘Comment/Serial number’ field during the ordering process. You will find the number on the type plate on the frame of the injection device.
Our range includes a large number of wear and spare parts. If you still cannot find what you are looking for, please do not hesitate to contact us via the contact form, by e-mail or by telephone. Our team will be happy to help you find the right part.